In this video we are going to learn the following things.
How to get started with Excel basic terminologies such as workbook worksheet rows columns and sales.
And lastly what is they been and what are the various tabs in the ribbon.
So let's start the first thing we have to do is start Microsoft Excel to start it should be installed
in your system.
If it is not installed you may need to visit the Microsoft website to download Microsoft Office.
If it is installed you can open excel by three methods.
The first is you go to the start option and you search for Excel and you click on it.
The other option is you use this search tool to look for Excel
and click on it.
The third option is by right clicking on the desktop going to new and selecting Microsoft Excel what
cheated
if you double click on it it opens a worksheet.
Once Excel opens you will see this window with many small rectangular boxes down here you can see your
tab saying sheet one.
You can add more sheets make clicking this plus icon.
Now you can see sheet to entry also.
Think of this window as your notebook and this sheet as the pages in your notebook.
This window is called Excel workbook and each sheet is called a worksheet so in Excel comes your notebook
corresponds to a workbook and a page in your notebook corresponds to a worksheet now if you open Excel
again that will open another bird book.
You can work on many workbooks simultaneously
so you can see that I have two workbooks active
and I can work on both of them simultaneously.
Now let us look at all the elements that we can see in this window.
Do not get intimidated by the number of elements.
Once you start working on Excel all this will come naturally to you.
So the major part of this screen is taken up by this set of small rectangles.
If you look closely these rectangles are formed by these vertical and horizontal lines.
These vertical pods are called columns and each column has an alphabet name.
If I click on this letter B it highlights the column B in a worksheet.
There are sixteen thousand three hundred eighty four such columns although you do not need to remember
this number.
But that is the number of columns we have in this worksheet.
Similarly the horizontal part are called rules and are represented by numbers.
If I click to the second row will be highlighted.
The maximum number of rows in a worksheet is over a million.
Now the intersection of the row and column create a rectangle.
This rectangle is called a cell.
So Column A and row one create a cell called a even.
No I told you that we have sixteen thousand three hundred eighty four columns and we have one million
forty eight thousand five hundred seventy six rules.
Can you find out the total number of cells in this worksheet.
And if I have three worksheets in this world book How many cells do I have in my workbook.
I will show you the answer to this question in the next video.
Let's move on for now.
Now this area is called the ribbon ribbon constitutes all these dads home insert page layout etc. and
all the options that you see within each step.
If you do not want to see the options in the tabs you can collapse.
There have been with this small button
marginally when I'm working on a file.
I usually prefer to keep them open.
Now remember that all these are tabs except this file button file Button has some other functionalities
and we will discuss that later.
For now I will give you a brief overview of these tabs in the videos to come.
We will dive deeper into all the options you see in these tabs.
The first tab is the hometown.
You'll probably spend most of your time with the Home tab selected.
This tab contains the basic clipboard commands such as cut copy paste formatting command styling command
and command to insert and delete rules or columns.
The second tab is Insert tab.
We use this tab to insert elements into a worksheet elements such as a table a diagram a chart a symbol
and so on page layout tab contains commands that affect the overall appearance of your worksheet including
some settings that deal with printing before tab is formalized tab which is used to insert a formula
name or cell or access formula.
Auditing tools etc. Next tab is Data tab where you will find data related commands including data validation
filtering sorting and advanced analysis tools.
Then comes the view tab which helps to review the content in your worksheet such as do spell checking
translate word or add comment.
The last tab is the view tab which contains commands that control various aspects of how a sheet is
viewed.
For example zooming or freezing beans within a worksheet.
So while explaining this I have used various Excel specific terms and you may not understand the meaning
of these terms right now but when we go through each of these functionality one by one in the course
you will understand what each option does.
So this might seem like a lot but trust me we will go step by step and when you see the examples of
how all these are used you will realize that Excel is very simple and very powerful tool.
Which is why it is very popular in businesses.
In the next video we are going to see how to enter data and formula in these cells.